inherited frmDynamicReportSet_EditMst: TfrmDynamicReportSet_EditMst
  Left = 286
  Top = 235
  Caption = #20108#27425#24320#21457
  ClientHeight = 619
  ClientWidth = 777
  ExplicitWidth = 785
  ExplicitHeight = 646
  DesignSize = (
    777
    619)
  PixelsPerInch = 96
  TextHeight = 12
  object Label2: TLabel [0]
    Left = 45
    Top = 21
    Width = 24
    Height = 12
    Caption = #26631#39064
    Transparent = True
  end
  object Label1: TLabel [1]
    Left = 560
    Top = 21
    Width = 48
    Height = 12
    Caption = #33756#21333#24207#21495
    Transparent = True
  end
  object Label5: TLabel [2]
    Left = 27
    Top = 105
    Width = 42
    Height = 12
    Caption = 'SQL'#33050#26412
  end
  inherited pnlBottom: TPanel
    Top = 559
    Width = 777
    TabOrder = 9
    ExplicitTop = 559
    ExplicitWidth = 777
    inherited Bevel1: TBevel
      Width = 777
      ExplicitWidth = 732
    end
    inherited btnOK: TBitBtn
      Left = 560
      Top = 20
      ModalResult = 0
      ExplicitLeft = 560
      ExplicitTop = 20
    end
    inherited btnCancel: TBitBtn
      Left = 660
      Top = 20
      ExplicitLeft = 660
      ExplicitTop = 20
    end
    inherited btnContinue: TBitBtn
      Left = 10
      Top = 20
      Visible = False
      ExplicitLeft = 10
      ExplicitTop = 20
    end
  end
  object edtType: TcxDBComboBox [4]
    Left = 72
    Top = 46
    DataBinding.DataField = 'iMR_Type'
    DataBinding.DataSource = MainDataSource
    Properties.DropDownListStyle = lsFixedList
    Properties.ImmediatePost = True
    Properties.Items.Strings = (
      #26597#35810#25253#34920
      #23384#20648#36807#31243#25253#34920
      #23457#26680#26816#26597
      #23457#26680'/'#21453#23457#26680#25191#34892
      #21333#25454#26597#35810
      #21333#25454#25191#34892
      #20854#20182'-'#24080#22871#21319#32423#25968#25454#20462#22797)
    TabOrder = 4
    Width = 160
  end
  object cxLabel1: TcxLabel [5]
    Left = 17
    Top = 48
    Caption = #33050#26412#31867#22411
    Transparent = True
  end
  object edtMenuOrderID: TcxDBSpinEdit [6]
    Left = 612
    Top = 17
    DataBinding.DataField = 'iMR_Menu_Order_ID'
    DataBinding.DataSource = MainDataSource
    TabOrder = 13
    Width = 100
  end
  object edtsMR_Table_Name: TcxDBTextEdit [7]
    Left = 72
    Top = 74
    DataBinding.DataField = 'sMR_Table_Name'
    DataBinding.DataSource = MainDataSource
    TabOrder = 6
    Width = 640
  end
  object edtSQLScript: TcxDBMemo [8]
    Left = 72
    Top = 105
    Anchors = [akLeft, akTop, akRight, akBottom]
    DataBinding.DataField = 'sMR_SQL'
    DataBinding.DataSource = MainDataSource
    Properties.ScrollBars = ssBoth
    TabOrder = 8
    Height = 402
    Width = 640
  end
  object edtsMR_ReportCaption: TcxDBTextEdit [9]
    Left = 72
    Top = 17
    DataBinding.DataField = 'sMR_ReportCaption'
    DataBinding.DataSource = MainDataSource
    TabOrder = 0
    Width = 220
  end
  object lblMenuGroup: TcxLabel [10]
    Left = 314
    Top = 19
    Caption = #33756#21333#20998#32452
    Transparent = True
  end
  object edtMenuGroup: TcxDBComboBox [11]
    Left = 370
    Top = 17
    DataBinding.DataField = 'sMR_MenuGroup'
    DataBinding.DataSource = MainDataSource
    Properties.DropDownListStyle = lsFixedList
    Properties.ImmediatePost = True
    Properties.Items.Strings = (
      #25253#34920
      #23457#26680#26816#26597
      #23457#26680'/'#21453#23457#26680#25191#34892
      #21333#25454#26597#35810
      #21333#25454#25191#34892
      #24080#22871#21319#32423#25968#25454#20462#22797)
    Properties.OnChange = edtMenuGroupPropertiesChange
    TabOrder = 15
    Width = 161
  end
  object btnExecSQL: TBitBtn [12]
    Left = 27
    Top = 519
    Width = 85
    Height = 23
    HelpType = htKeyword
    Anchors = [akLeft, akBottom]
    Caption = #36816#34892#33050#26412
    Glyph.Data = {
      76010000424D7601000000000000760000002800000020000000100000000100
      04000000000000010000120B0000120B00001000000000000000000000000000
      800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
      FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00500000000055
      555557777777775F55550FFFFFFFFF0555557F5555555F7FFF5F0FEEEEEE0000
      05007F555555777775770FFFFFF0BFBFB00E7F5F5557FFF557770F0EEEE000FB
      FB0E7F75FF57775555770FF00F0FBFBFBF0E7F57757FFFF555770FE0B00000FB
      FB0E7F575777775555770FFF0FBFBFBFBF0E7F5575FFFFFFF5770FEEE0000000
      FB0E7F555777777755770FFFFF0B00BFB0007F55557577FFF7770FEEEEE0B000
      05557F555557577775550FFFFFFF0B0555557FF5F5F57575F55500F0F0F0F0B0
      555577F7F7F7F7F75F5550707070700B055557F7F7F7F7757FF5507070707050
      9055575757575757775505050505055505557575757575557555}
    NumGlyphs = 2
    TabOrder = 10
    OnClick = btnExecSQLClick
  end
  object btnExample: TBitBtn [13]
    Left = 118
    Top = 519
    Width = 85
    Height = 23
    HelpType = htKeyword
    Anchors = [akLeft, akBottom]
    Caption = #26174#31034#33539#20363
    Glyph.Data = {
      76010000424D7601000000000000760000002800000020000000100000000100
      04000000000000010000120B0000120B00001000000000000000000000000000
      800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
      FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00500000000055
      555557777777775F55550FFFFFFFFF0555557F5555555F7FFF5F0FEEEEEE0000
      05007F555555777775770FFFFFF0BFBFB00E7F5F5557FFF557770F0EEEE000FB
      FB0E7F75FF57775555770FF00F0FBFBFBF0E7F57757FFFF555770FE0B00000FB
      FB0E7F575777775555770FFF0FBFBFBFBF0E7F5575FFFFFFF5770FEEE0000000
      FB0E7F555777777755770FFFFF0B00BFB0007F55557577FFF7770FEEEEE0B000
      05557F555557577775550FFFFFFF0B0555557FF5F5F57575F55500F0F0F0F0B0
      555577F7F7F7F7F75F5550707070700B055557F7F7F7F7757FF5507070707050
      9055575757575757775505050505055505557575757575557555}
    NumGlyphs = 2
    TabOrder = 11
    OnClick = btnExampleClick
  end
  object btnReportDesign: TcxButton [14]
    Left = 231
    Top = 43
    Width = 60
    Height = 25
    Caption = #35774#35745#22120
    TabOrder = 3
    Visible = False
    OnClick = btnReportDesignClick
  end
  object lblExecSQL: TcxLabel [15]
    Left = 17
    Top = 76
    Caption = #25191#34892#33050#26412
    Transparent = True
  end
  object lblBType: TcxLabel [16]
    Left = 314
    Top = 48
    Caption = #21333#25454#31867#22411
    Transparent = True
  end
  object edtBType: TcxComboBox [17]
    Left = 370
    Top = 46
    Properties.OnChange = edtBTypePropertiesChange
    TabOrder = 5
    Text = 'edtBType'
    Width = 161
  end
  object memExample: TcxMemo [18]
    Left = 72
    Top = 105
    Anchors = [akLeft, akTop, akRight, akBottom]
    Lines.Strings = (
      
        'if exists (select * from dbo.sysobjects where id = object_id(N'#39'[' +
        'dbo].[pr_aa]'#39') and OBJECTPROPERTY(id, '
      'N'#39'IsProcedure'#39') = 1)'
      '  drop procedure [dbo].[pr_aa]'
      'GO'
      'create procedure pr_aa'
      '('
      '  @sdate datetime,'
      '  @edate datetime,'
      '  @filtersql nvarchar(4000)'
      ')'
      'as'
      'begin'
      '  declare @sql nvarchar(4000)'
      
        '  set @sql = N'#39' select * from v_tb_sale where m_bdate>='#39#39#39'+conve' +
        'rt(varchar(30), @sdate, 23) '
      
        '    +'#39#39#39' and m_bdate<='#39#39#39'+convert(varchar(30), @edate, 23)+'#39#39#39#39' ' +
        '+@filtersql'
      '  execute sp_executesql @sql '
      'end'
      '/****************************************************'
      #25191#34892#33050#26412#65306'  pr_aa :sdate,:edate,:filtersql'
      #21629#21517#35268#21017#65306'  '
      '                      '#23384#20648#36807#31243'[p_+'#21517#31216' '#25110' pr_+'#21517#31216']  '
      '                      '#34920'[t_+'#21517#31216']  '
      '                      '#35270#22270'[v_+'#21517#31216']  '
      '                      '#20989#25968'[f_+'#21517#31216']'
      
        #21442#25968#35828#26126#65306'  :sdate '#24320#22987#26085#26399'        :edate '#25130#27490#26085#26399'              :filtersql'#36807#28388#26465 +
        #20214
      
        '                      :currfilid '#24403#26399#20998#25903'     :curruserid '#24403#21069#25805#20316#21592'   :b' +
        'id '#24403#21069#21333#25454'ID'
      ''
      #23457#26680#26816#26597'  '#23457#26680'/'#21453#23457#26680#25191#34892'      '#19968#31181#21333#25454#21482#33021#26377#19968#20010
      #21333#25454#26597#35810'  '#21333#25454#25191#34892'                   '#19968#31181#21333#25454#21487#20197#26377#22810#20010
      '****************************************************/')
    Style.Shadow = False
    TabOrder = 7
    Visible = False
    Height = 376
    Width = 640
  end
  inherited btnPrint: TcxButton
    Visible = False
  end
  inherited edtPrint: TcxLookupComboBox
    Visible = False
  end
  inherited MainDataSource: TDataSource
    DataSet = MainDataSet
    Left = 190
    Top = 143
  end
  inherited qryReportDtl: TUniQuery
    Left = 728
    Top = 49
  end
  inherited dsReportDtl: TDataSource
    Left = 648
    Top = 57
  end
  object qyTmp: TUniQuery
    Connection = MainDM.UniConn
    Left = 277
    Top = 89
  end
  object MainDataSet: TUniQuery
    Connection = MainDM.UniConn
    SQL.Strings = (
      'select * from ts_dynamicreportmst')
    Options.PrepareUpdateSQL = True
    Options.SetFieldsReadOnly = False
    Options.RequiredFields = False
    Options.QueryRecCount = True
    Options.AutoPrepare = True
    Left = 163
    Top = 91
  end
  object sptExec: TUniScript
    Connection = MainDM.UniConn
    Left = 328
    Top = 184
  end
end
